﻿CREATE TABLE [dbo].[Order_Change_Audit] (
    [Id]    INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CId]   INT              NOT NULL,
    [OId]   UNIQUEIDENTIFIER NOT NULL,
    [shpr]  NVARCHAR (30)    NULL,
    [shprq] DATETIME         CONSTRAINT [DF_Order_Change_Audit_shprq] DEFAULT (getdate()) NOT NULL,
    [shpyj] NVARCHAR (500)   NULL,
    CONSTRAINT [PK_Order_Change_Audit] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Order_Change_Audit_OId]
    ON [dbo].[Order_Change_Audit]([OId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Order_Change_Audit_CId]
    ON [dbo].[Order_Change_Audit]([CId] ASC);

